﻿namespace etracks.Sales.Controllers
{
    using System;
    using System.Collections.Generic;
    using System.Linq;
    using System.Web;

    /// <summary>
    /// Summary description for PostgresController
    /// </summary>
    public class PostgresController
    {
        public PostgresController()
        {
        } // public PostgresController()

        public void Connect()
        {
            Npgsql.NpgsqlConnection conn = new Npgsql.NpgsqlConnection();
            Npgsql.NpgsqlCommand cmd = conn.CreateCommand();
            cmd.CommandType = System.Data.CommandType.Text;
            Npgsql.NpgsqlDataAdapter da = new Npgsql.NpgsqlDataAdapter(cmd);
            System.Data.DataSet ds = new System.Data.DataSet();
            cmd.CommandText = "SELECT * FROM sales.application_setting;";
            da.Fill(ds);
            

            
        } // public void Connect()
    } // public class PostgresController
} // namespace etracks.Sales.Controllers